<%@ page import="java.sql.*,studentportal.*"%>
<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>

<body>
<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<!--mstheme--><font face="Trebuchet MS, Arial, Helvetica"><!--mstheme--></font>

<table border="0" width="100%">
  <tr>
    <td width="100%"><!--mstheme--><font face="Trebuchet MS, Arial, Helvetica"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;<!--mstheme--></font></td>
  </tr>
</table>
<!--mstheme--><font face="Trebuchet MS, Arial, Helvetica"><!--mstheme--></font>
<table border="1" width="100%">
  <tr>
    <td width="100%">&nbsp;</td>
  </tr>
</table>
<%
					System.out.println("ss");
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					ResultSet rs=st.executeQuery("select * from examination_master");
%>

<br><br><br>
<!--mstheme--><font face="Trebuchet MS, Arial, Helvetica">

<table border="1" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
	<tr>
		<th>Exam ID</th>
		<th>Exam Name</th>
		<th>Exam Type</th>
		<th>Course ID</th>
		<th>Sem  ID</th>
		<th>Subject ID</th>
		<th>Exam Start Date</th>
		<th>Exam End Date</th>
		<th>Exam Fee</th>
	</tr>
	<%
			while(rs.next())
			{
	%>
				<tr>
						<td><%=rs.getString(1)%></td>
						<td><%=rs.getString(2)%></td>
						<td><%=rs.getString(3)%></td>
						<td><%=rs.getString(4)%></td>
						<td><%=rs.getString(5)%></td>
						<td><%=rs.getString(6)%></td>
						<td><%=rs.getDate(7)%></td>
						<td><%=rs.getDate(8)%></td>
						<td><%=rs.getFloat(9)%></td>
				</tr>
	<%
			}
			//rs.close();
			st.close();
			con.close();
	%>

</table>
</body>

</html>
